1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id=
"milkdairyDataSet" targetNamespace="http://tempuri.org/milkdairyDataSet.xsd" xmlns:mstns="http://tempuri.org/milkdairyDataSet.xsd" xmlns="http://tempuri.org/milkdairyDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source=
"urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex=
"0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName=
"Settings" AppSettingsPropertyName="milkdairyConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="milkdairyConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MilkDairyManagementSystemCSharp.Properties.Settings.GlobalReference.Default.milkdairyConnectionString" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass=
"System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dairyTableAdapter" GeneratorDataComponentClassName="dairyTableAdapter" Name="dairy" UserDataComponentName="dairyTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef=
"milkdairyConnectionString (Settings)" DbObjectName="dbo.dairy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[dairy] WHERE (([Id] = @Original_Id) AND ((@IsNull_acnt_no =
1 AND [acnt_no] IS NULL) OR ([acnt_no] = @Original_acnt_no)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_d_no = 1 AND [d_no] IS NULL) OR ([d_no] = @Original_d_no)) AND ((@IsNull_liter = 1 AND [liter] IS NULL) OR ([liter] = @Original_liter)) AND ((@IsNull_fate = 1 AND [fate] IS NULL) OR ([fate] = @Original_fate)) AND ((@IsNull_pperl = 1 AND [pperl] IS NULL) OR ([pperl] = @Original_pperl)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acnt_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_d_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Original" />
26                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_liter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="true" SourceVersion="Original" />
27                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Original" />
28                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="true" SourceVersion="Original" />
29                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Original" />
30                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pperl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="true" SourceVersion="Original" />
31                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Original" />
32                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
33                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
34                     </Parameters>
35                   </DbCommand>
36                 </DeleteCommand>
37                 <InsertCommand>
38                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
39                     <CommandText>INSERT INTO [dbo].[dairy] ([acnt_no], [name], [addr], [d_no], [liter], [fate], [pperl], [total]) VALUES (@acnt_no, @name, @addr, @d_no, @liter, @fate, @pperl, @total);
40 SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dairy WHERE (Id = SCOPE_IDENTITY())</CommandText>
41                     <Parameters>
42                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Current" />
43                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
44                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
45                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Current" />
46                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Current" />
47                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Current" />
48                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Current" />
49                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
50                     </Parameters>
51                   </DbCommand>
52                 </InsertCommand>
53                 <SelectCommand>
54                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
55                     <CommandText>SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dbo.dairy</CommandText>
56                     <Parameters />
57                   </DbCommand>
58                 </SelectCommand>
59                 <UpdateCommand>
60                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
61                     <CommandText>UPDATE [dbo].[dairy] SET [acnt_no] = @acnt_no, [name] = @name, [addr] = @addr, [d_no] = @d_no, [liter] = @liter, [fate] = @fate, [pperl] = @pperl, [total] = @total WHERE (([Id] = @Original_Id) AND ((@IsNull_acnt_no =
1 AND [acnt_no] IS NULL) OR ([acnt_no] = @Original_acnt_no)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_d_no = 1 AND [d_no] IS NULL) OR ([d_no] = @Original_d_no)) AND ((@IsNull_liter = 1 AND [liter] IS NULL) OR ([liter] = @Original_liter)) AND ((@IsNull_fate = 1 AND [fate] IS NULL) OR ([fate] = @Original_fate)) AND ((@IsNull_pperl = 1 AND [pperl] IS NULL) OR ([pperl] = @Original_pperl)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)));
62 SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dairy WHERE (Id = @Id)</CommandText>
63                     <Parameters>
64                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Current" />
65                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
66                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
67                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Current" />
68                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Current" />
69                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Current" />
70                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Current" />
71                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
72                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
73                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acnt_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="true" SourceVersion="Original" />
74                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Original" />
75                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
76                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
77                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
78                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
79                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_d_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="true" SourceVersion="Original" />
80                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Original" />
81                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_liter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="true" SourceVersion="Original" />
82                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Original" />
83                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="true" SourceVersion="Original" />
84                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Original" />
85                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pperl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="true" SourceVersion="Original" />
86                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Original" />
87                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
88                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
89                       <Parameter AllowDbNull=
"false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[7B85E66E5B47A16D9E4F6DAC01C44393_DIO 2015\PROJECTS\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRY.MDF].dbo.dairy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
90                     </Parameters>
91                   </DbCommand>
92                 </UpdateCommand>
93               </DbSource>
94             </MainSource>
95             <Mappings>
96               <Mapping SourceColumn=
"Id" DataSetColumn="Id" />
97               <Mapping SourceColumn=
"acnt_no" DataSetColumn="acnt_no" />
98               <Mapping SourceColumn=
"name" DataSetColumn="name" />
99               <Mapping SourceColumn=
"addr" DataSetColumn="addr" />
100               <Mapping SourceColumn=
"d_no" DataSetColumn="d_no" />
101               <Mapping SourceColumn=
"liter" DataSetColumn="liter" />
102               <Mapping SourceColumn=
"fate" DataSetColumn="fate" />
103               <Mapping SourceColumn=
"pperl" DataSetColumn="pperl" />
104               <Mapping SourceColumn=
"total" DataSetColumn="total" />
105             </Mappings>
106             <Sources />
107           </TableAdapter>
108         </Tables>
109         <Sources />
110       </DataSource>
111     </xs:appinfo>
112   </xs:annotation>
113   <xs:element name=
"milkdairyDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="milkdairyDataSet" msprop:Generator_UserDSName="milkdairyDataSet">
114     <xs:complexType>
115       <xs:choice minOccurs=
"0" maxOccurs="unbounded">
116         <xs:element name=
"dairy" msprop:Generator_TableClassName="dairyDataTable" msprop:Generator_TableVarName="tabledairy" msprop:Generator_TablePropName="dairy" msprop:Generator_RowDeletingName="dairyRowDeleting" msprop:Generator_RowChangingName="dairyRowChanging" msprop:Generator_RowEvHandlerName="dairyRowChangeEventHandler" msprop:Generator_RowDeletedName="dairyRowDeleted" msprop:Generator_UserTableName="dairy" msprop:Generator_RowChangedName="dairyRowChanged" msprop:Generator_RowEvArgName="dairyRowChangeEvent" msprop:Generator_RowClassName="dairyRow">
117           <xs:complexType>
118             <xs:sequence>
119               <xs:element name=
"Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
120               <xs:element name=
"acnt_no" msprop:Generator_ColumnVarNameInTable="columnacnt_no" msprop:Generator_ColumnPropNameInRow="acnt_no" msprop:Generator_ColumnPropNameInTable="acnt_noColumn" msprop:Generator_UserColumnName="acnt_no" minOccurs="0">
121                 <xs:simpleType>
122                   <xs:restriction
base="xs:string">
123                     <xs:maxLength
value="50" />
124                   </xs:restriction>
125                 </xs:simpleType>
126               </xs:element>
127               <xs:element name=
"name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
128                 <xs:simpleType>
129                   <xs:restriction
base="xs:string">
130                     <xs:maxLength
value="50" />
131                   </xs:restriction>
132                 </xs:simpleType>
133               </xs:element>
134               <xs:element name=
"addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" msprop:Generator_UserColumnName="addr" minOccurs="0">
135                 <xs:simpleType>
136                   <xs:restriction
base="xs:string">
137                     <xs:maxLength
value="50" />
138                   </xs:restriction>
139                 </xs:simpleType>
140               </xs:element>
141               <xs:element name=
"d_no" msprop:Generator_ColumnVarNameInTable="columnd_no" msprop:Generator_ColumnPropNameInRow="d_no" msprop:Generator_ColumnPropNameInTable="d_noColumn" msprop:Generator_UserColumnName="d_no" minOccurs="0">
142                 <xs:simpleType>
143                   <xs:restriction
base="xs:string">
144                     <xs:maxLength
value="50" />
145                   </xs:restriction>
146                 </xs:simpleType>
147               </xs:element>
148               <xs:element name=
"liter" msprop:Generator_ColumnVarNameInTable="columnliter" msprop:Generator_ColumnPropNameInRow="liter" msprop:Generator_ColumnPropNameInTable="literColumn" msprop:Generator_UserColumnName="liter" minOccurs="0">
149                 <xs:simpleType>
150                   <xs:restriction
base="xs:string">
151                     <xs:maxLength
value="50" />
152                   </xs:restriction>
153                 </xs:simpleType>
154               </xs:element>
155               <xs:element name=
"fate" msprop:Generator_ColumnVarNameInTable="columnfate" msprop:Generator_ColumnPropNameInRow="fate" msprop:Generator_ColumnPropNameInTable="fateColumn" msprop:Generator_UserColumnName="fate" minOccurs="0">
156                 <xs:simpleType>
157                   <xs:restriction
base="xs:string">
158                     <xs:maxLength
value="50" />
159                   </xs:restriction>
160                 </xs:simpleType>
161               </xs:element>
162               <xs:element name=
"pperl" msprop:Generator_ColumnVarNameInTable="columnpperl" msprop:Generator_ColumnPropNameInRow="pperl" msprop:Generator_ColumnPropNameInTable="pperlColumn" msprop:Generator_UserColumnName="pperl" minOccurs="0">
163                 <xs:simpleType>
164                   <xs:restriction
base="xs:string">
165                     <xs:maxLength
value="50" />
166                   </xs:restriction>
167                 </xs:simpleType>
168               </xs:element>
169               <xs:element name=
"total" msprop:Generator_ColumnVarNameInTable="columntotal" msprop:Generator_ColumnPropNameInRow="total" msprop:Generator_ColumnPropNameInTable="totalColumn" msprop:Generator_UserColumnName="total" minOccurs="0">
170                 <xs:simpleType>
171                   <xs:restriction
base="xs:string">
172                     <xs:maxLength
value="50" />
173                   </xs:restriction>
174                 </xs:simpleType>
175               </xs:element>
176             </xs:sequence>
177           </xs:complexType>
178         </xs:element>
179       </xs:choice>
180     </xs:complexType>
181     <xs:unique name=
"Constraint1" msdata:PrimaryKey="true">
182       <xs:selector xpath=
".//mstns:dairy" />
183       <xs:field xpath=
"mstns:Id" />
184     </xs:unique>
185   </xs:element>
186 </xs:schema>


Gõ tìm kiếm nhanh...